Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 513863 |
| Missing cells | 240184 |
| Missing cells (%) | 2.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 78.4 MiB |
| Average record size in memory | 160.0 B |
Variable types
| Numeric | 12 |
|---|---|
| Categorical | 8 |
date_time has a high cardinality: 43182 distinct values | High cardinality |
zipcode has a high cardinality: 15038 distinct values | High cardinality |
year_home_built is highly overall correlated with days_since_last_visit | High correlation |
home_market_value is highly overall correlated with net_worth and 5 other fields | High correlation |
net_worth is highly overall correlated with home_market_value and 2 other fields | High correlation |
income is highly overall correlated with home_market_value and 2 other fields | High correlation |
mkt_organic_product_purchasers_value is highly overall correlated with home_market_value and 3 other fields | High correlation |
mkt_trend_env_focused_hh_value is highly overall correlated with home_market_value and 4 other fields | High correlation |
high_end_shoppers_value is highly overall correlated with home_market_value and 4 other fields | High correlation |
do_it_yourselfer_value is highly overall correlated with home_market_value and 3 other fields | High correlation |
mkt_green_product_purchasers_value is highly overall correlated with mkt_organic_product_purchasers_value and 1 other fields | High correlation |
days_since_last_visit is highly overall correlated with year_home_built | High correlation |
success is highly imbalanced (71.5%) | Imbalance |
days_since_last_visit has 107835 (21.0%) missing values | Missing |
year_home_built has 11962 (2.3%) missing values | Missing |
home_market_value has 11962 (2.3%) missing values | Missing |
length_of_residence has 11962 (2.3%) missing values | Missing |
net_worth has 11962 (2.3%) missing values | Missing |
income has 11962 (2.3%) missing values | Missing |
mkt_organic_product_purchasers_value has 11962 (2.3%) missing values | Missing |
mkt_trend_env_focused_hh_value has 11962 (2.3%) missing values | Missing |
high_end_shoppers_value has 11962 (2.3%) missing values | Missing |
do_it_yourselfer_value has 11962 (2.3%) missing values | Missing |
montrd_home_security_sys_own_value has 11962 (2.3%) missing values | Missing |
mkt_green_product_purchasers_value has 11962 (2.3%) missing values | Missing |
visit_id is uniformly distributed | Uniform |
visit_id has unique values | Unique |
Reproduction
| Analysis started | 2022-12-29 18:29:16.164758 |
|---|---|
| Analysis finished | 2022-12-29 18:31:24.847699 |
| Duration | 2 minutes and 8.68 seconds |
| Software version | pandas-profiling vv3.6.1 |
| Download configuration | config.json |
visit_id
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 513863 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 256931 |
| Minimum | 0 |
|---|---|
| Maximum | 513862 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 25693.1 |
| Q1 | 128465.5 |
| median | 256931 |
| Q3 | 385396.5 |
| 95-th percentile | 488168.9 |
| Maximum | 513862 |
| Range | 513862 |
| Interquartile range (IQR) | 256931 |
Descriptive statistics
| Standard deviation | 148339.62 |
|---|---|
| Coefficient of variation (CV) | 0.57735195 |
| Kurtosis | -1.2 |
| Mean | 256931 |
| Median Absolute Deviation (MAD) | 128466 |
| Skewness | 1.9078039 × 10-19 |
| Sum | 1.3202733 × 1011 |
| Variance | 2.2004641 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 14167 | 1 | < 0.1% |
| 191702 | 1 | < 0.1% |
| 331337 | 1 | < 0.1% |
| 148651 | 1 | < 0.1% |
| 458868 | 1 | < 0.1% |
| 469465 | 1 | < 0.1% |
| 504982 | 1 | < 0.1% |
| 450156 | 1 | < 0.1% |
| 425742 | 1 | < 0.1% |
| 407741 | 1 | < 0.1% |
| Other values (513853) | 513853 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 513862 | 1 | |
| 513861 | 1 | |
| 513860 | 1 | |
| 513859 | 1 | |
| 513858 | 1 | |
| 513857 | 1 | |
| 513856 | 1 | |
| 513855 | 1 | |
| 513854 | 1 | |
| 513853 | 1 |
date_time
Categorical
| Distinct | 43182 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 6/24/19 13:23 | 51 |
|---|---|
| 6/27/19 12:41 | 47 |
| 6/27/19 9:29 | 47 |
| 6/28/19 11:20 | 47 |
| 6/27/19 13:53 | 47 |
| Other values (43177) |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 12.557596 |
| Min length | 11 |
Characters and Unicode
| Total characters | 6452884 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1710 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 5/31/19 10:36 |
|---|---|
| 2nd row | 5/31/19 10:37 |
| 3rd row | 5/31/19 10:37 |
| 4th row | 5/31/19 10:37 |
| 5th row | 5/31/19 10:37 |
Common Values
| Value | Count | Frequency (%) |
| 6/24/19 13:23 | 51 | < 0.1% |
| 6/27/19 12:41 | 47 | < 0.1% |
| 6/27/19 9:29 | 47 | < 0.1% |
| 6/28/19 11:20 | 47 | < 0.1% |
| 6/27/19 13:53 | 47 | < 0.1% |
| 6/27/19 13:50 | 46 | < 0.1% |
| 6/27/19 13:47 | 46 | < 0.1% |
| 6/28/19 12:48 | 46 | < 0.1% |
| 6/24/19 13:14 | 46 | < 0.1% |
| 6/26/19 13:46 | 45 | < 0.1% |
| Other values (43172) | 513395 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 6/27/19 | 26184 | 2.5% |
| 6/24/19 | 25534 | 2.5% |
| 6/26/19 | 25338 | 2.5% |
| 6/25/19 | 24464 | 2.4% |
| 6/28/19 | 23988 | 2.3% |
| 6/20/19 | 21734 | 2.1% |
| 6/18/19 | 21638 | 2.1% |
| 6/19/19 | 21011 | 2.0% |
| 6/21/19 | 20591 | 2.0% |
| 6/30/19 | 20468 | 2.0% |
| Other values (1461) | 796776 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1240089 | |
| / | 1027726 | |
| 9 | 672449 | |
| 6 | 645589 | |
| 2 | 547019 | |
| 513863 | ||
| : | 513863 | |
| 3 | 265145 | 4.1% |
| 0 | 263272 | 4.1% |
| 5 | 229643 | 3.6% |
| Other values (3) | 534226 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4397432 | |
| Other Punctuation | 1541589 | 23.9% |
| Space Separator | 513863 | 8.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1240089 | |
| 9 | 672449 | |
| 6 | 645589 | |
| 2 | 547019 | |
| 3 | 265145 | 6.0% |
| 0 | 263272 | 6.0% |
| 5 | 229643 | 5.2% |
| 4 | 228887 | 5.2% |
| 8 | 156344 | 3.6% |
| 7 | 148995 | 3.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 1027726 | |
| : | 513863 |
Space Separator
| Value | Count | Frequency (%) |
| 513863 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 6452884 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 1240089 | |
| / | 1027726 | |
| 9 | 672449 | |
| 6 | 645589 | |
| 2 | 547019 | |
| 513863 | ||
| : | 513863 | |
| 3 | 265145 | 4.1% |
| 0 | 263272 | 4.1% |
| 5 | 229643 | 3.6% |
| Other values (3) | 534226 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6452884 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 1240089 | |
| / | 1027726 | |
| 9 | 672449 | |
| 6 | 645589 | |
| 2 | 547019 | |
| 513863 | ||
| : | 513863 | |
| 3 | 265145 | 4.1% |
| 0 | 263272 | 4.1% |
| 5 | 229643 | 3.6% |
| Other values (3) | 534226 |
experience
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| version2 | |
|---|---|
| version1 |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 4110904 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | version1 |
|---|---|
| 2nd row | version1 |
| 3rd row | version2 |
| 4th row | version1 |
| 5th row | version2 |
Common Values
| Value | Count | Frequency (%) |
| version2 | 257284 | |
| version1 | 256579 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| version2 | 257284 | |
| version1 | 256579 |
Most occurring characters
| Value | Count | Frequency (%) |
| v | 513863 | |
| e | 513863 | |
| r | 513863 | |
| s | 513863 | |
| i | 513863 | |
| o | 513863 | |
| n | 513863 | |
| 2 | 257284 | |
| 1 | 256579 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3597041 | |
| Decimal Number | 513863 | 12.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| v | 513863 | |
| e | 513863 | |
| r | 513863 | |
| s | 513863 | |
| i | 513863 | |
| o | 513863 | |
| n | 513863 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 257284 | |
| 1 | 256579 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3597041 | |
| Common | 513863 | 12.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| v | 513863 | |
| e | 513863 | |
| r | 513863 | |
| s | 513863 | |
| i | 513863 | |
| o | 513863 | |
| n | 513863 |
Common
| Value | Count | Frequency (%) |
| 2 | 257284 | |
| 1 | 256579 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4110904 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| v | 513863 | |
| e | 513863 | |
| r | 513863 | |
| s | 513863 | |
| i | 513863 | |
| o | 513863 | |
| n | 513863 | |
| 2 | 257284 | |
| 1 | 256579 |
success
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 0 | |
|---|---|
| 1 | 25551 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 513863 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 488312 | |
| 1 | 25551 | 5.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 488312 | |
| 1 | 25551 | 5.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 488312 | |
| 1 | 25551 | 5.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 513863 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 488312 | |
| 1 | 25551 | 5.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 513863 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 488312 | |
| 1 | 25551 | 5.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 513863 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 488312 | |
| 1 | 25551 | 5.0% |
zipcode
Categorical
| Distinct | 15038 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 767 |
| Missing (%) | 0.1% |
| Memory size | 3.9 MiB |
| 30080 | 17902 |
|---|---|
| 97229 | 10764 |
| 30339 | 6014 |
| 7205 | 4921 |
| 94043 | 4178 |
| Other values (15033) |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 4.9382689 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2533806 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2255 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 30080 |
|---|---|
| 2nd row | 32081 |
| 3rd row | 91124 |
| 4th row | 60614 |
| 5th row | 76309 |
Common Values
| Value | Count | Frequency (%) |
| 30080 | 17902 | 3.5% |
| 97229 | 10764 | 2.1% |
| 30339 | 6014 | 1.2% |
| 7205 | 4921 | 1.0% |
| 94043 | 4178 | 0.8% |
| 77035 | 3445 | 0.7% |
| 7014 | 2524 | 0.5% |
| 80202 | 2210 | 0.4% |
| 60602 | 1878 | 0.4% |
| 10011 | 1703 | 0.3% |
| Other values (15028) | 457557 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 30080 | 17902 | 3.5% |
| 97229 | 10764 | 2.1% |
| 30339 | 6014 | 1.2% |
| 7205 | 4921 | 1.0% |
| 94043 | 4178 | 0.8% |
| 77035 | 3445 | 0.7% |
| 7014 | 2524 | 0.5% |
| 80202 | 2210 | 0.4% |
| 60602 | 1878 | 0.4% |
| 0a1 | 1846 | 0.4% |
| Other values (15111) | 460636 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 405509 | |
| 3 | 308968 | |
| 2 | 291541 | |
| 1 | 287650 | |
| 7 | 235300 | |
| 9 | 213443 | |
| 8 | 208757 | |
| 4 | 200645 | |
| 5 | 194919 | |
| 6 | 172744 | |
| Other values (27) | 14330 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2519476 | |
| Lowercase Letter | 10725 | 0.4% |
| Space Separator | 3222 | 0.1% |
| Dash Punctuation | 383 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 3115 | |
| m | 989 | 9.2% |
| l | 787 | 7.3% |
| v | 602 | 5.6% |
| n | 601 | 5.6% |
| h | 485 | 4.5% |
| s | 462 | 4.3% |
| e | 452 | 4.2% |
| g | 418 | 3.9% |
| c | 401 | 3.7% |
| Other values (15) | 2413 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 405509 | |
| 3 | 308968 | |
| 2 | 291541 | |
| 1 | 287650 | |
| 7 | 235300 | |
| 9 | 213443 | |
| 8 | 208757 | |
| 4 | 200645 | |
| 5 | 194919 | |
| 6 | 172744 |
Space Separator
| Value | Count | Frequency (%) |
| 3222 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 383 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2523081 | |
| Latin | 10725 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 3115 | |
| m | 989 | 9.2% |
| l | 787 | 7.3% |
| v | 602 | 5.6% |
| n | 601 | 5.6% |
| h | 485 | 4.5% |
| s | 462 | 4.3% |
| e | 452 | 4.2% |
| g | 418 | 3.9% |
| c | 401 | 3.7% |
| Other values (15) | 2413 |
Common
| Value | Count | Frequency (%) |
| 0 | 405509 | |
| 3 | 308968 | |
| 2 | 291541 | |
| 1 | 287650 | |
| 7 | 235300 | |
| 9 | 213443 | |
| 8 | 208757 | |
| 4 | 200645 | |
| 5 | 194919 | |
| 6 | 172744 | |
| Other values (2) | 3605 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2533806 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 405509 | |
| 3 | 308968 | |
| 2 | 291541 | |
| 1 | 287650 | |
| 7 | 235300 | |
| 9 | 213443 | |
| 8 | 208757 | |
| 4 | 200645 | |
| 5 | 194919 | |
| 6 | 172744 | |
| Other values (27) | 14330 | 0.6% |
pro
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 513863 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 421771 | |
| 1 | 92092 | 17.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 421771 | |
| 1 | 92092 | 17.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 421771 | |
| 1 | 92092 | 17.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 513863 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 421771 | |
| 1 | 92092 | 17.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 513863 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 421771 | |
| 1 | 92092 | 17.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 513863 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 421771 | |
| 1 | 92092 | 17.9% |
repeat_visit
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 513863 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 416487 | |
| 0 | 97376 | 18.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 416487 | |
| 0 | 97376 | 18.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 416487 | |
| 0 | 97376 | 18.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 513863 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 416487 | |
| 0 | 97376 | 18.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 513863 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 416487 | |
| 0 | 97376 | 18.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 513863 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 416487 | |
| 0 | 97376 | 18.9% |
days_since_last_visit
Categorical
HIGH CORRELATION MISSING
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 107835 |
| Missing (%) | 21.0% |
| Memory size | 3.9 MiB |
| less than 1 day | |
|---|---|
| less than 7 days | |
| first visit | |
| more than 7 days | 21412 |
| more than 30 days | 1455 |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 14.740203 |
| Min length | 11 |
Characters and Unicode
| Total characters | 5984935 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | less than 7 days |
|---|---|
| 2nd row | less than 7 days |
| 3rd row | less than 1 day |
| 4th row | less than 7 days |
| 5th row | more than 7 days |
Common Values
| Value | Count | Frequency (%) |
| less than 1 day | 230358 | |
| less than 7 days | 96195 | |
| first visit | 56522 | 11.0% |
| more than 7 days | 21412 | 4.2% |
| more than 30 days | 1455 | 0.3% |
| more than a year | 86 | < 0.1% |
| (Missing) | 107835 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| than | 349506 | |
| less | 326553 | |
| 1 | 230358 | |
| day | 230358 | |
| days | 119062 | 7.9% |
| 7 | 117607 | 7.8% |
| first | 56522 | 3.7% |
| visit | 56522 | 3.7% |
| more | 22953 | 1.5% |
| 30 | 1455 | 0.1% |
| Other values (2) | 172 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1105040 | ||
| s | 885212 | |
| a | 699098 | |
| t | 462550 | |
| e | 349592 | 5.8% |
| y | 349506 | 5.8% |
| h | 349506 | 5.8% |
| n | 349506 | 5.8% |
| d | 349420 | 5.8% |
| l | 326553 | 5.5% |
| Other values (10) | 758952 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4529020 | |
| Space Separator | 1105040 | 18.5% |
| Decimal Number | 350875 | 5.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 885212 | |
| a | 699098 | |
| t | 462550 | |
| e | 349592 | 7.7% |
| y | 349506 | 7.7% |
| h | 349506 | 7.7% |
| n | 349506 | 7.7% |
| d | 349420 | 7.7% |
| l | 326553 | 7.2% |
| i | 169566 | 3.7% |
| Other values (5) | 238511 | 5.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 230358 | |
| 7 | 117607 | |
| 3 | 1455 | 0.4% |
| 0 | 1455 | 0.4% |
Space Separator
| Value | Count | Frequency (%) |
| 1105040 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4529020 | |
| Common | 1455915 | 24.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 885212 | |
| a | 699098 | |
| t | 462550 | |
| e | 349592 | 7.7% |
| y | 349506 | 7.7% |
| h | 349506 | 7.7% |
| n | 349506 | 7.7% |
| d | 349420 | 7.7% |
| l | 326553 | 7.2% |
| i | 169566 | 3.7% |
| Other values (5) | 238511 | 5.3% |
Common
| Value | Count | Frequency (%) |
| 1105040 | ||
| 1 | 230358 | 15.8% |
| 7 | 117607 | 8.1% |
| 3 | 1455 | 0.1% |
| 0 | 1455 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5984935 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1105040 | ||
| s | 885212 | |
| a | 699098 | |
| t | 462550 | |
| e | 349592 | 5.8% |
| y | 349506 | 5.8% |
| h | 349506 | 5.8% |
| n | 349506 | 5.8% |
| d | 349420 | 5.8% |
| l | 326553 | 5.5% |
| Other values (10) | 758952 |
new_movers
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 513863 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 347126 | |
| 1 | 166737 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 347126 | |
| 1 | 166737 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 347126 | |
| 1 | 166737 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 513863 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 347126 | |
| 1 | 166737 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 513863 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 347126 | |
| 1 | 166737 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 513863 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 347126 | |
| 1 | 166737 |
year_home_built
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 109 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1980.672 |
| Minimum | 0 |
|---|---|
| Maximum | 2017 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1957 |
| Q1 | 1973 |
| median | 1984 |
| Q3 | 1989 |
| 95-th percentile | 1998 |
| Maximum | 2017 |
| Range | 2017 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 13.098487 |
|---|---|
| Coefficient of variation (CV) | 0.0066131532 |
| Kurtosis | 1041.7595 |
| Mean | 1980.672 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -7.5693038 |
| Sum | 9.9410126 × 108 |
| Variance | 171.57037 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1987 | 34895 | 6.8% |
| 1986 | 25640 | 5.0% |
| 1989 | 25215 | 4.9% |
| 1988 | 17810 | 3.5% |
| 1978 | 17477 | 3.4% |
| 1976 | 16551 | 3.2% |
| 1984 | 16078 | 3.1% |
| 1983 | 15573 | 3.0% |
| 1985 | 15233 | 3.0% |
| 1979 | 13584 | 2.6% |
| Other values (99) | 303845 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1900 | 13 | |
| 1902 | 4 | < 0.1% |
| 1904 | 6 | |
| 1905 | 1 | < 0.1% |
| 1908 | 1 | < 0.1% |
| 1910 | 8 | |
| 1911 | 1 | < 0.1% |
| 1914 | 12 | |
| 1915 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2017 | 6 | < 0.1% |
| 2016 | 3 | < 0.1% |
| 2015 | 6 | < 0.1% |
| 2014 | 4 | < 0.1% |
| 2013 | 5 | < 0.1% |
| 2012 | 26 | < 0.1% |
| 2011 | 8 | < 0.1% |
| 2010 | 20 | < 0.1% |
| 2009 | 3 | < 0.1% |
| 2008 | 72 |
home_market_value
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 886 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 343.19592 |
| Minimum | 4 |
|---|---|
| Maximum | 2628 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 171 |
| Q1 | 239 |
| median | 310 |
| Q3 | 413 |
| 95-th percentile | 630 |
| Maximum | 2628 |
| Range | 2624 |
| Interquartile range (IQR) | 174 |
Descriptive statistics
| Standard deviation | 150.48762 |
|---|---|
| Coefficient of variation (CV) | 0.43848896 |
| Kurtosis | 4.3253086 |
| Mean | 343.19592 |
| Median Absolute Deviation (MAD) | 79 |
| Skewness | 1.5776755 |
| Sum | 1.7225037 × 108 |
| Variance | 22646.524 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 320 | 18673 | 3.6% |
| 555 | 10964 | 2.1% |
| 266 | 7954 | 1.5% |
| 293 | 5622 | 1.1% |
| 235 | 5480 | 1.1% |
| 520 | 4407 | 0.9% |
| 442 | 4183 | 0.8% |
| 416 | 3559 | 0.7% |
| 247 | 3440 | 0.7% |
| 360 | 3282 | 0.6% |
| Other values (876) | 434337 | |
| (Missing) | 11962 | 2.3% |
| Value | Count | Frequency (%) |
| 4 | 6 | < 0.1% |
| 10 | 6 | < 0.1% |
| 14 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 16 | 66 | |
| 17 | 6 | < 0.1% |
| 19 | 1 | < 0.1% |
| 20 | 3 | < 0.1% |
| 24 | 5 | < 0.1% |
| 26 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 2628 | 1 | < 0.1% |
| 2496 | 1 | < 0.1% |
| 1991 | 4 | < 0.1% |
| 1842 | 3 | < 0.1% |
| 1790 | 3 | < 0.1% |
| 1650 | 15 | |
| 1563 | 16 | |
| 1493 | 28 | |
| 1492 | 5 | < 0.1% |
| 1483 | 21 |
length_of_residence
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.004557 |
| Minimum | 0.25 |
|---|---|
| Maximum | 23 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0.25 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 8 |
| median | 13 |
| Q3 | 13 |
| 95-th percentile | 13 |
| Maximum | 23 |
| Range | 22.75 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.9633743 |
|---|---|
| Coefficient of variation (CV) | 0.26928612 |
| Kurtosis | 0.43215711 |
| Mean | 11.004557 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.29332319 |
| Sum | 5523198 |
| Variance | 8.7815874 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 13 | 268995 | |
| 8 | 209301 | |
| 18 | 14750 | 2.9% |
| 4 | 5522 | 1.1% |
| 23 | 2768 | 0.5% |
| 1.5 | 303 | 0.1% |
| 0.75 | 166 | < 0.1% |
| 0.25 | 96 | < 0.1% |
| (Missing) | 11962 | 2.3% |
| Value | Count | Frequency (%) |
| 0.25 | 96 | < 0.1% |
| 0.75 | 166 | < 0.1% |
| 1.5 | 303 | 0.1% |
| 4 | 5522 | 1.1% |
| 8 | 209301 | |
| 13 | 268995 | |
| 18 | 14750 | 2.9% |
| 23 | 2768 | 0.5% |
| Value | Count | Frequency (%) |
| 23 | 2768 | 0.5% |
| 18 | 14750 | 2.9% |
| 13 | 268995 | |
| 8 | 209301 | |
| 4 | 5522 | 1.1% |
| 1.5 | 303 | 0.1% |
| 0.75 | 166 | < 0.1% |
| 0.25 | 96 | < 0.1% |
net_worth
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 288908.64 |
| Minimum | 12500 |
|---|---|
| Maximum | 1000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 12500 |
|---|---|
| 5-th percentile | 150000 |
| Q1 | 150000 |
| median | 250000 |
| Q3 | 250000 |
| 95-th percentile | 750000 |
| Maximum | 1000000 |
| Range | 987500 |
| Interquartile range (IQR) | 100000 |
Descriptive statistics
| Standard deviation | 165392.37 |
|---|---|
| Coefficient of variation (CV) | 0.5724729 |
| Kurtosis | 3.2696796 |
| Mean | 288908.64 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.7509761 |
| Sum | 1.4500354 × 1011 |
| Variance | 2.7354636 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 250000 | 270236 | |
| 150000 | 104374 | 20.3% |
| 500000 | 77763 | 15.1% |
| 750000 | 21935 | 4.3% |
| 100000 | 17394 | 3.4% |
| 1000000 | 4411 | 0.9% |
| 75000 | 2930 | 0.6% |
| 50000 | 1044 | 0.2% |
| 12500 | 961 | 0.2% |
| 25000 | 853 | 0.2% |
| (Missing) | 11962 | 2.3% |
| Value | Count | Frequency (%) |
| 12500 | 961 | 0.2% |
| 25000 | 853 | 0.2% |
| 50000 | 1044 | 0.2% |
| 75000 | 2930 | 0.6% |
| 100000 | 17394 | 3.4% |
| 150000 | 104374 | 20.3% |
| 250000 | 270236 | |
| 500000 | 77763 | 15.1% |
| 750000 | 21935 | 4.3% |
| 1000000 | 4411 | 0.9% |
| Value | Count | Frequency (%) |
| 1000000 | 4411 | 0.9% |
| 750000 | 21935 | 4.3% |
| 500000 | 77763 | 15.1% |
| 250000 | 270236 | |
| 150000 | 104374 | 20.3% |
| 100000 | 17394 | 3.4% |
| 75000 | 2930 | 0.6% |
| 50000 | 1044 | 0.2% |
| 25000 | 853 | 0.2% |
| 12500 | 961 | 0.2% |
income
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100913.02 |
| Minimum | 10000 |
|---|---|
| Maximum | 250000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 75000 |
| Q1 | 75000 |
| median | 100000 |
| Q3 | 125000 |
| 95-th percentile | 150000 |
| Maximum | 250000 |
| Range | 240000 |
| Interquartile range (IQR) | 50000 |
Descriptive statistics
| Standard deviation | 28175.24 |
|---|---|
| Coefficient of variation (CV) | 0.27920323 |
| Kurtosis | 1.5045767 |
| Mean | 100913.02 |
| Median Absolute Deviation (MAD) | 25000 |
| Skewness | 0.80978464 |
| Sum | 5.0648345 × 1010 |
| Variance | 7.9384417 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| 100000 | 179388 | |
| 75000 | 149998 | |
| 125000 | 113926 | |
| 50000 | 19673 | 3.8% |
| 150000 | 17741 | 3.5% |
| 175000 | 15706 | 3.1% |
| 200000 | 3202 | 0.6% |
| 40000 | 871 | 0.2% |
| 250000 | 519 | 0.1% |
| 30000 | 461 | 0.1% |
| Other values (3) | 416 | 0.1% |
| (Missing) | 11962 | 2.3% |
| Value | Count | Frequency (%) |
| 10000 | 114 | < 0.1% |
| 15000 | 81 | < 0.1% |
| 20000 | 221 | < 0.1% |
| 30000 | 461 | 0.1% |
| 40000 | 871 | 0.2% |
| 50000 | 19673 | 3.8% |
| 75000 | 149998 | |
| 100000 | 179388 | |
| 125000 | 113926 | |
| 150000 | 17741 | 3.5% |
| Value | Count | Frequency (%) |
| 250000 | 519 | 0.1% |
| 200000 | 3202 | 0.6% |
| 175000 | 15706 | 3.1% |
| 150000 | 17741 | 3.5% |
| 125000 | 113926 | |
| 100000 | 179388 | |
| 75000 | 149998 | |
| 50000 | 19673 | 3.8% |
| 40000 | 871 | 0.2% |
| 30000 | 461 | 0.1% |
mkt_organic_product_purchasers_value
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.220549 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 29 |
| median | 36 |
| Q3 | 46 |
| 95-th percentile | 64 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 13.052736 |
|---|---|
| Coefficient of variation (CV) | 0.34151096 |
| Kurtosis | 0.63336244 |
| Mean | 38.220549 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.82829228 |
| Sum | 19182932 |
| Variance | 170.37393 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 29 | 31227 | 6.1% |
| 34 | 23394 | 4.6% |
| 32 | 22708 | 4.4% |
| 23 | 18890 | 3.7% |
| 37 | 18398 | 3.6% |
| 36 | 17963 | 3.5% |
| 33 | 17860 | 3.5% |
| 35 | 15786 | 3.1% |
| 38 | 15731 | 3.1% |
| 31 | 15148 | 2.9% |
| Other values (89) | 304796 |
| Value | Count | Frequency (%) |
| 1 | 59 | |
| 2 | 30 | < 0.1% |
| 3 | 45 | < 0.1% |
| 4 | 77 | |
| 5 | 51 | |
| 6 | 37 | < 0.1% |
| 7 | 50 | |
| 8 | 16 | < 0.1% |
| 9 | 115 | |
| 10 | 76 |
| Value | Count | Frequency (%) |
| 99 | 15 | < 0.1% |
| 98 | 18 | < 0.1% |
| 97 | 11 | < 0.1% |
| 96 | 47 | < 0.1% |
| 95 | 68 | |
| 94 | 40 | < 0.1% |
| 93 | 24 | < 0.1% |
| 92 | 37 | < 0.1% |
| 91 | 123 | |
| 90 | 60 |
mkt_trend_env_focused_hh_value
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.381515 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 21 |
| median | 30 |
| Q3 | 40 |
| 95-th percentile | 57 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 13.952084 |
|---|---|
| Coefficient of variation (CV) | 0.44459561 |
| Kurtosis | 0.33974362 |
| Mean | 31.381515 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.65046944 |
| Sum | 15750414 |
| Variance | 194.66065 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25 | 31830 | 6.2% |
| 32 | 22194 | 4.3% |
| 30 | 17435 | 3.4% |
| 11 | 16407 | 3.2% |
| 20 | 16075 | 3.1% |
| 22 | 13589 | 2.6% |
| 28 | 13392 | 2.6% |
| 27 | 13374 | 2.6% |
| 29 | 12974 | 2.5% |
| 26 | 12604 | 2.5% |
| Other values (89) | 332027 |
| Value | Count | Frequency (%) |
| 1 | 29 | < 0.1% |
| 2 | 40 | < 0.1% |
| 3 | 59 | < 0.1% |
| 4 | 190 | < 0.1% |
| 5 | 634 | 0.1% |
| 6 | 1151 | 0.2% |
| 7 | 1604 | 0.3% |
| 8 | 5232 | |
| 9 | 2297 | |
| 10 | 5316 |
| Value | Count | Frequency (%) |
| 99 | 4 | < 0.1% |
| 98 | 41 | |
| 97 | 14 | < 0.1% |
| 96 | 20 | < 0.1% |
| 95 | 25 | |
| 94 | 25 | |
| 93 | 47 | |
| 92 | 41 | |
| 91 | 33 | |
| 90 | 54 |
high_end_shoppers_value
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.23937 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 25 |
| median | 30 |
| Q3 | 37 |
| 95-th percentile | 49 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 10.195232 |
|---|---|
| Coefficient of variation (CV) | 0.32635843 |
| Kurtosis | 1.7434001 |
| Mean | 31.23937 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.86842298 |
| Sum | 15679071 |
| Variance | 103.94275 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25 | 39099 | 7.6% |
| 26 | 31695 | 6.2% |
| 33 | 23228 | 4.5% |
| 23 | 20568 | 4.0% |
| 28 | 20438 | 4.0% |
| 37 | 17684 | 3.4% |
| 36 | 17643 | 3.4% |
| 29 | 16916 | 3.3% |
| 31 | 16480 | 3.2% |
| 27 | 16301 | 3.2% |
| Other values (89) | 281849 |
| Value | Count | Frequency (%) |
| 1 | 29 | < 0.1% |
| 2 | 61 | < 0.1% |
| 3 | 40 | < 0.1% |
| 4 | 47 | < 0.1% |
| 5 | 75 | < 0.1% |
| 6 | 90 | < 0.1% |
| 7 | 73 | < 0.1% |
| 8 | 98 | < 0.1% |
| 9 | 365 | |
| 10 | 766 |
| Value | Count | Frequency (%) |
| 99 | 13 | < 0.1% |
| 98 | 8 | < 0.1% |
| 97 | 14 | < 0.1% |
| 96 | 22 | |
| 95 | 34 | |
| 94 | 11 | < 0.1% |
| 93 | 7 | < 0.1% |
| 92 | 19 | |
| 91 | 36 | |
| 90 | 22 |
do_it_yourselfer_value
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 98 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.192526 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 38 |
| median | 47 |
| Q3 | 55 |
| 95-th percentile | 67 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 12.655106 |
|---|---|
| Coefficient of variation (CV) | 0.27396437 |
| Kurtosis | 0.1197245 |
| Mean | 46.192526 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.23593066 |
| Sum | 23184075 |
| Variance | 160.15172 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 55 | 28010 | 5.5% |
| 47 | 24948 | 4.9% |
| 54 | 20194 | 3.9% |
| 45 | 17668 | 3.4% |
| 50 | 17449 | 3.4% |
| 52 | 16650 | 3.2% |
| 42 | 15363 | 3.0% |
| 49 | 14986 | 2.9% |
| 48 | 13949 | 2.7% |
| 44 | 13896 | 2.7% |
| Other values (88) | 318788 |
| Value | Count | Frequency (%) |
| 1 | 119 | < 0.1% |
| 2 | 75 | < 0.1% |
| 3 | 132 | < 0.1% |
| 4 | 165 | < 0.1% |
| 5 | 198 | |
| 6 | 223 | |
| 7 | 451 | |
| 8 | 313 | |
| 9 | 319 | |
| 10 | 486 |
| Value | Count | Frequency (%) |
| 99 | 1 | < 0.1% |
| 98 | 16 | |
| 97 | 10 | |
| 96 | 1 | < 0.1% |
| 95 | 14 | |
| 93 | 10 | |
| 92 | 7 | |
| 91 | 15 | |
| 90 | 1 | < 0.1% |
| 89 | 5 | < 0.1% |
montrd_home_security_sys_own_value
Real number (ℝ)
| Distinct | 98 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.515315 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 18 |
| Q1 | 25 |
| median | 29 |
| Q3 | 35 |
| 95-th percentile | 46 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 8.9727219 |
|---|---|
| Coefficient of variation (CV) | 0.29403996 |
| Kurtosis | 3.2071592 |
| Mean | 30.515315 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 1.0847744 |
| Sum | 15315667 |
| Variance | 80.509738 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 28 | 41698 | 8.1% |
| 29 | 31195 | 6.1% |
| 30 | 24892 | 4.8% |
| 24 | 24452 | 4.8% |
| 32 | 24225 | 4.7% |
| 26 | 23569 | 4.6% |
| 27 | 22352 | 4.3% |
| 25 | 20939 | 4.1% |
| 23 | 19484 | 3.8% |
| 33 | 18411 | 3.6% |
| Other values (88) | 250684 |
| Value | Count | Frequency (%) |
| 1 | 60 | < 0.1% |
| 2 | 27 | < 0.1% |
| 3 | 31 | < 0.1% |
| 4 | 104 | < 0.1% |
| 5 | 99 | < 0.1% |
| 6 | 464 | |
| 7 | 100 | < 0.1% |
| 8 | 110 | < 0.1% |
| 9 | 228 | |
| 10 | 206 |
| Value | Count | Frequency (%) |
| 99 | 15 | |
| 97 | 4 | < 0.1% |
| 96 | 14 | |
| 95 | 14 | |
| 94 | 8 | < 0.1% |
| 93 | 26 | |
| 92 | 27 | |
| 91 | 24 | |
| 90 | 14 | |
| 89 | 18 |
mkt_green_product_purchasers_value
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11962 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.994419 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 28 |
| Q1 | 38 |
| median | 46 |
| Q3 | 51 |
| 95-th percentile | 62 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 10.438021 |
|---|---|
| Coefficient of variation (CV) | 0.23198479 |
| Kurtosis | 0.52123524 |
| Mean | 44.994419 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.19278834 |
| Sum | 22582744 |
| Variance | 108.95228 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 39 | 32741 | 6.4% |
| 47 | 28743 | 5.6% |
| 46 | 28697 | 5.6% |
| 51 | 27959 | 5.4% |
| 35 | 19953 | 3.9% |
| 40 | 19574 | 3.8% |
| 49 | 18505 | 3.6% |
| 42 | 17701 | 3.4% |
| 44 | 17633 | 3.4% |
| 50 | 16826 | 3.3% |
| Other values (89) | 273569 |
| Value | Count | Frequency (%) |
| 1 | 27 | < 0.1% |
| 2 | 5 | < 0.1% |
| 3 | 25 | < 0.1% |
| 4 | 6 | < 0.1% |
| 5 | 26 | < 0.1% |
| 6 | 62 | |
| 7 | 33 | < 0.1% |
| 8 | 100 | |
| 9 | 44 | |
| 10 | 40 | < 0.1% |
| Value | Count | Frequency (%) |
| 99 | 6 | < 0.1% |
| 98 | 15 | < 0.1% |
| 97 | 54 | |
| 96 | 36 | |
| 95 | 36 | |
| 94 | 39 | |
| 93 | 46 | |
| 92 | 49 | |
| 91 | 61 | |
| 90 | 51 |
| visit_id | year_home_built | home_market_value | length_of_residence | net_worth | income | mkt_organic_product_purchasers_value | mkt_trend_env_focused_hh_value | high_end_shoppers_value | do_it_yourselfer_value | montrd_home_security_sys_own_value | mkt_green_product_purchasers_value | experience | success | pro | repeat_visit | days_since_last_visit | new_movers | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| visit_id | 1.000 | -0.024 | 0.002 | 0.035 | 0.006 | 0.008 | 0.024 | 0.007 | 0.020 | -0.029 | 0.013 | 0.018 | 0.014 | 0.019 | 0.041 | 0.042 | 0.044 | 0.006 |
| year_home_built | -0.024 | 1.000 | -0.176 | -0.323 | -0.123 | -0.037 | 0.142 | 0.367 | 0.185 | -0.177 | -0.415 | 0.093 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 |
| home_market_value | 0.002 | -0.176 | 1.000 | -0.124 | 0.708 | 0.763 | -0.592 | -0.737 | -0.603 | 0.562 | -0.053 | -0.468 | 0.013 | 0.017 | 0.039 | 0.056 | 0.077 | 0.008 |
| length_of_residence | 0.035 | -0.323 | -0.124 | 1.000 | 0.056 | -0.071 | 0.164 | 0.100 | 0.071 | -0.119 | 0.008 | 0.224 | 0.009 | 0.014 | 0.046 | 0.029 | 0.034 | 0.006 |
| net_worth | 0.006 | -0.123 | 0.708 | 0.056 | 1.000 | 0.760 | -0.321 | -0.485 | -0.522 | 0.424 | -0.170 | -0.178 | 0.013 | 0.017 | 0.019 | 0.057 | 0.072 | 0.002 |
| income | 0.008 | -0.037 | 0.763 | -0.071 | 0.760 | 1.000 | -0.341 | -0.474 | -0.569 | 0.472 | -0.207 | -0.179 | 0.014 | 0.016 | 0.028 | 0.071 | 0.088 | 0.001 |
| mkt_organic_product_purchasers_value | 0.024 | 0.142 | -0.592 | 0.164 | -0.321 | -0.341 | 1.000 | 0.694 | 0.430 | -0.510 | 0.101 | 0.621 | 0.009 | 0.024 | 0.051 | 0.041 | 0.118 | 0.010 |
| mkt_trend_env_focused_hh_value | 0.007 | 0.367 | -0.737 | 0.100 | -0.485 | -0.474 | 0.694 | 1.000 | 0.558 | -0.622 | -0.100 | 0.606 | 0.010 | 0.017 | 0.058 | 0.055 | 0.162 | 0.004 |
| high_end_shoppers_value | 0.020 | 0.185 | -0.603 | 0.071 | -0.522 | -0.569 | 0.430 | 0.558 | 1.000 | -0.723 | 0.207 | 0.245 | 0.010 | 0.022 | 0.048 | 0.023 | 0.051 | 0.004 |
| do_it_yourselfer_value | -0.029 | -0.177 | 0.562 | -0.119 | 0.424 | 0.472 | -0.510 | -0.622 | -0.723 | 1.000 | -0.248 | -0.373 | 0.019 | 0.025 | 0.060 | 0.031 | 0.080 | 0.005 |
| montrd_home_security_sys_own_value | 0.013 | -0.415 | -0.053 | 0.008 | -0.170 | -0.207 | 0.101 | -0.100 | 0.207 | -0.248 | 1.000 | -0.062 | 0.016 | 0.015 | 0.040 | 0.030 | 0.069 | 0.005 |
| mkt_green_product_purchasers_value | 0.018 | 0.093 | -0.468 | 0.224 | -0.178 | -0.179 | 0.621 | 0.606 | 0.245 | -0.373 | -0.062 | 1.000 | 0.006 | 0.023 | 0.052 | 0.039 | 0.075 | 0.003 |
| experience | 0.014 | 0.000 | 0.013 | 0.009 | 0.013 | 0.014 | 0.009 | 0.010 | 0.010 | 0.019 | 0.016 | 0.006 | 1.000 | 0.000 | 0.000 | 0.001 | 0.010 | 0.428 |
| success | 0.019 | 0.000 | 0.017 | 0.014 | 0.017 | 0.016 | 0.024 | 0.017 | 0.022 | 0.025 | 0.015 | 0.023 | 0.000 | 1.000 | 0.048 | 0.035 | 0.077 | 0.006 |
| pro | 0.041 | 0.000 | 0.039 | 0.046 | 0.019 | 0.028 | 0.051 | 0.058 | 0.048 | 0.060 | 0.040 | 0.052 | 0.000 | 0.048 | 1.000 | 0.084 | 0.183 | 0.000 |
| repeat_visit | 0.042 | 0.000 | 0.056 | 0.029 | 0.057 | 0.071 | 0.041 | 0.055 | 0.023 | 0.031 | 0.030 | 0.039 | 0.001 | 0.035 | 0.084 | 1.000 | 0.226 | 0.000 |
| days_since_last_visit | 0.044 | 1.000 | 0.077 | 0.034 | 0.072 | 0.088 | 0.118 | 0.162 | 0.051 | 0.080 | 0.069 | 0.075 | 0.010 | 0.077 | 0.183 | 0.226 | 1.000 | 0.007 |
| new_movers | 0.006 | 0.000 | 0.008 | 0.006 | 0.002 | 0.001 | 0.010 | 0.004 | 0.004 | 0.005 | 0.005 | 0.003 | 0.428 | 0.006 | 0.000 | 0.000 | 0.007 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| visit_id | date_time | experience | success | zipcode | pro | repeat_visit | days_since_last_visit | new_movers | year_home_built | home_market_value | length_of_residence | net_worth | income | mkt_organic_product_purchasers_value | mkt_trend_env_focused_hh_value | high_end_shoppers_value | do_it_yourselfer_value | montrd_home_security_sys_own_value | mkt_green_product_purchasers_value | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 14167 | 5/31/19 10:36 | version1 | 0 | 30080 | 0 | 0 | NaN | 0 | 1987.0 | 320.0 | 8.0 | 250000.0 | 100000.0 | 29.0 | 25.0 | 25.0 | 55.0 | 28.0 | 39.0 |
| 1 | 195581 | 5/31/19 10:37 | version1 | 0 | 32081 | 1 | 0 | NaN | 0 | 2006.0 | 366.0 | 4.0 | 250000.0 | 125000.0 | 40.0 | 28.0 | 23.0 | 60.0 | 18.0 | 46.0 |
| 2 | 451142 | 5/31/19 10:37 | version2 | 0 | 91124 | 0 | 0 | NaN | 0 | 1988.0 | 504.0 | 13.0 | 500000.0 | 125000.0 | 21.0 | 12.0 | 16.0 | 76.0 | 32.0 | 31.0 |
| 3 | 278496 | 5/31/19 10:37 | version1 | 0 | 60614 | 1 | 0 | NaN | 0 | 1968.0 | 433.0 | 8.0 | 500000.0 | 125000.0 | 37.0 | 10.0 | 12.0 | 80.0 | 40.0 | 37.0 |
| 4 | 316757 | 5/31/19 10:37 | version2 | 0 | 76309 | 0 | 1 | less than 7 days | 0 | 1976.0 | 208.0 | 8.0 | 250000.0 | 100000.0 | 52.0 | 48.0 | 24.0 | 35.0 | 24.0 | 62.0 |
| 5 | 486252 | 5/31/19 10:37 | version2 | 1 | 65401 | 0 | 0 | NaN | 0 | 1987.0 | 176.0 | 13.0 | 150000.0 | 75000.0 | 69.0 | 25.0 | 55.0 | 20.0 | 40.0 | 38.0 |
| 6 | 121996 | 5/31/19 10:37 | version2 | 0 | 60712 | 0 | 0 | NaN | 0 | 1957.0 | 406.0 | 13.0 | 250000.0 | 100000.0 | 29.0 | 24.0 | 18.0 | 63.0 | 37.0 | 53.0 |
| 7 | 363058 | 5/31/19 10:37 | version2 | 0 | 87112 | 1 | 1 | less than 7 days | 0 | 1974.0 | 227.0 | 13.0 | 250000.0 | 75000.0 | 39.0 | 22.0 | 42.0 | 38.0 | 33.0 | 39.0 |
| 8 | 246436 | 5/31/19 10:37 | version1 | 0 | 72116 | 0 | 1 | less than 1 day | 1 | 1973.0 | 215.0 | 13.0 | 150000.0 | 75000.0 | 47.0 | 56.0 | 30.0 | 41.0 | 17.0 | 61.0 |
| 9 | 108770 | 5/31/19 10:38 | version2 | 0 | 1886 | 0 | 0 | NaN | 0 | 1979.0 | 497.0 | 13.0 | 500000.0 | 150000.0 | 32.0 | 13.0 | 20.0 | 46.0 | 38.0 | 51.0 |
| visit_id | date_time | experience | success | zipcode | pro | repeat_visit | days_since_last_visit | new_movers | year_home_built | home_market_value | length_of_residence | net_worth | income | mkt_organic_product_purchasers_value | mkt_trend_env_focused_hh_value | high_end_shoppers_value | do_it_yourselfer_value | montrd_home_security_sys_own_value | mkt_green_product_purchasers_value | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 513853 | 13346 | 6/30/19 23:58 | version1 | 0 | 60453 | 1 | 1 | less than 7 days | 1 | 1961.0 | 228.0 | 18.0 | 250000.0 | 75000.0 | 47.0 | 49.0 | 35.0 | 38.0 | 36.0 | 62.0 |
| 513854 | 471490 | 6/30/19 23:58 | version2 | 0 | 33778 | 0 | 1 | less than 1 day | 0 | 1973.0 | 254.0 | 13.0 | 250000.0 | 75000.0 | 44.0 | 31.0 | 40.0 | 38.0 | 29.0 | 50.0 |
| 513855 | 108807 | 6/30/19 23:58 | version1 | 0 | 7205 | 0 | 1 | first visit | 0 | 1958.0 | 293.0 | 13.0 | 250000.0 | 75000.0 | 19.0 | 17.0 | 28.0 | 54.0 | 24.0 | 55.0 |
| 513856 | 69888 | 6/30/19 23:58 | version2 | 0 | 96001 | 0 | 1 | less than 7 days | 0 | 1985.0 | 246.0 | 13.0 | 150000.0 | 75000.0 | 37.0 | 30.0 | 42.0 | 32.0 | 35.0 | 36.0 |
| 513857 | 108673 | 6/30/19 23:58 | version2 | 0 | 97229 | 0 | 1 | first visit | 0 | 1989.0 | 555.0 | 8.0 | 500000.0 | 125000.0 | 23.0 | 11.0 | 26.0 | 47.0 | 29.0 | 35.0 |
| 513858 | 382921 | 6/30/19 23:59 | version2 | 0 | 98362 | 1 | 1 | less than 1 day | 0 | 1978.0 | 267.0 | 13.0 | 250000.0 | 100000.0 | 42.0 | 31.0 | 52.0 | 28.0 | 42.0 | 37.0 |
| 513859 | 186356 | 6/30/19 23:59 | version1 | 0 | 72712 | 0 | 1 | less than 1 day | 0 | 2001.0 | 260.0 | 8.0 | 250000.0 | 100000.0 | 45.0 | 55.0 | 29.0 | 39.0 | 24.0 | 46.0 |
| 513860 | 355431 | 6/30/19 23:59 | version1 | 0 | 63146 | 0 | 1 | less than 1 day | 1 | 1970.0 | 237.0 | 13.0 | 250000.0 | 100000.0 | 46.0 | 32.0 | 33.0 | 42.0 | 33.0 | 49.0 |
| 513861 | 480424 | 6/30/19 23:59 | version1 | 0 | 70526 | 0 | 1 | NaN | 1 | 2000.0 | 170.0 | 18.0 | 100000.0 | 75000.0 | 66.0 | 52.0 | 35.0 | 36.0 | 27.0 | 67.0 |
| 513862 | 454425 | 6/30/19 23:59 | version1 | 0 | 94538 | 0 | 1 | less than 1 day | 0 | 1966.0 | 507.0 | 13.0 | 250000.0 | 125000.0 | 33.0 | 21.0 | 32.0 | 53.0 | 32.0 | 28.0 |